﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spTitle_Retrieve')
	BEGIN
		PRINT 'Dropping Procedure spTitle_Retrieve'
		DROP  Procedure  spTitle_Retrieve
	END

GO

PRINT 'Creating Procedure spTitle_Retrieve'
GO
CREATE PROCEDURE [dbo].[spTitle_Retrieve]
	(
		@Title_ID	bigint
	)
AS
	/* 
		------------------------------------------------------------------------------
		- Change History
		- --------------
		- Date									Description
		------------------------------------------------------------------------------
		- 14/02/2011 14:07:12  Initial version created
		------------------------------------------------------------------------------
	*/

	-- Declare the required variables

	-- Retrieve the required record
	SELECT  *
	FROM    [Title]
	WHERE		[Title].[Title_ID] = @Title_ID

	-- Return to calling method
	RETURN 
